Model Table ASSET HEALTH INDICATOR
Attributes
| Attribute |
Description (where applicable) |
| Asset Group | Represents the Asset Group (Equipment/Linea Asset/Etc.) |
| Asset Health Indicator Count | |
| Description | Represents the Description of the Indicator Type |
| Dim_Asset_Type | Dimension ID for Asset Type |
| ID | Key for Indicator setup value by Asset Group - Combination of Asset Group + Asset Type + Indicator Type + Parameter |
| Indicator Type | Represents the type of the Indicator (Parameter, Age, Condition Score, etc.) |
| Indicator Type Desc | Description of the Indicator Type |
| Mvt_Created_Dt | |
| OBJECT_TYPE | Represents the Asset Type |
| Parameter | Represents the Parameter ID of the indicator ( "-" if not a parameter) |
| Parameter Description | Description of the parameter (Blank if not a parameter) |
| Parameter Type | Represents the Type of the Parameter - Only for Parameters. Blank if not a parameter (Limit, Accumalated or Condition) |
| ParameterID | Represents a name for the parameter (If parameter - Parameter ID, else - Indicator Type) |
| Type | Represents the Type of the Indicator (Limit, Accumalated, Condition, Age, Condition Score, etc.) |
| Weight | Represents the allocated Weight for the Indicator to be used for calculations |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| ASSET HEALTH INDICATOR | FACT_ASSET_HEALTH_INDICATOR_TM | FACT_ASSET_HEALTH_INDICATOR_BI | FACT_ASSET_HEALTH_INDICATOR | On Line |